﻿using System;
using System.Data;
using WP.Commons;

namespace WP.RM.DataEntity
{

    //=========MCity  ============================
    [System.ComponentModel.DesignerCategory("Code")]
    public class RMWorkQtyInputHdrDEL : DataSet, IDataEntity
    {
        //=========mCity ============================
        public const string TABLENAME_RMWorkQtyInputHdr = "RMWorkQtyInputHdr";
        public const string RecID = "RecID";
        public const string WorkShopSeqNo = "WorkShopSeqNo";
        public const string WorkDate = "WorkDate";
        public const string InputDate = "InputDate";
        public const string WorkGroupSeqNo = "WorkGroupSeqNo";
        public const string WorkingProcedureID = "WorkingProcedureID";
        public const string WorkingProcedureName = "WorkingProcedureName";
        public const string ProductFItemID = "ProductFItemID";
        public const string ProductName = "ProductName";
        public const string ProductID="ProductID";
        public const string Unit = "Unit";
        public const string WorkQty = "WorkQty";
        public const string CalType = "CalType";
        public const string Recstamp = "Recstamp";
        public const string WorkGroupName = "WorkGroupName";
        public const string WorkShopName = "WorkShopName";
        public const string SemiCode = "SemiCode";
        public const string SemiName = "SemiName";
        public const string SemiRecID = "SemiRecID";
        public const string MachineSeqNo = "MachineSeqNo";
        public const string MachineName = "MachineName";
        public const string Remark = "Remark";
        public const string RecStamp = "RecStamp";
        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public RMWorkQtyInputHdrDEL()
        {
            //Create mCity structure
            CreatemCityStructure();

        }

        //=========mCity============================
        private void CreatemCityStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_RMWorkQtyInputHdr);
            DCC = table.Columns;

            DC = new DataColumn(RecID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(WorkShopSeqNo, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(WorkDate, typeof(System.DateTime));            
            DCC.Add(DC);

            DC = new DataColumn(InputDate, typeof(System.DateTime));            
            DCC.Add(DC);

            DC = new DataColumn(WorkGroupSeqNo, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);


            DC = new DataColumn(RecStamp, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(WorkingProcedureID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(WorkingProcedureName, typeof(System.String));
            DC.DefaultValue = ""; 
            DCC.Add(DC);

            DC = new DataColumn(ProductFItemID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(ProductName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(ProductID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(Unit, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(WorkQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CalType, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(WorkGroupName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(WorkShopName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(Remark, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SemiCode, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SemiName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(MachineSeqNo, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(MachineName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SemiRecID, typeof(System.Int32));
            DC.DefaultValue = 0;
            DCC.Add(DC);
            
            this.Tables.Add(table);
        }
    }
}
